﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SQL2005_390264_devpoleposiDataSet" targetNamespace="http://tempuri.org/SQL2005_390264_devpoleposiDataSet2.xsd" xmlns:mstns="http://tempuri.org/SQL2005_390264_devpoleposiDataSet2.xsd" xmlns="http://tempuri.org/SQL2005_390264_devpoleposiDataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SQL2005_390264_devpoleposiConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SQL2005_390264_devpoleposiConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PPIReporting.Properties.Settings.GlobalReference.Default.SQL2005_390264_devpoleposiConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="up_Report_ProjectSummaryTableAdapter" GeneratorDataComponentClassName="up_Report_ProjectSummaryTableAdapter" Name="up_Report_ProjectSummary" UserDataComponentName="up_Report_ProjectSummaryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQL2005_390264_devpoleposiConnectionString (Settings)" DbObjectName="SQL2005_390264_devpoleposi.dbo.up_Report_ProjectSummary" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.up_Report_ProjectSummary</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Utility_ProjectId" DataSetColumn="Utility_ProjectId" />
              <Mapping SourceColumn="UtilityFK" DataSetColumn="UtilityFK" />
              <Mapping SourceColumn="VendorFk" DataSetColumn="VendorFk" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ScheduledStartDate" DataSetColumn="ScheduledStartDate" />
              <Mapping SourceColumn="ActualStartDate" DataSetColumn="ActualStartDate" />
              <Mapping SourceColumn="ScheduledEndDate" DataSetColumn="ScheduledEndDate" />
              <Mapping SourceColumn="ActualEndDate" DataSetColumn="ActualEndDate" />
              <Mapping SourceColumn="ScheduledCost" DataSetColumn="ScheduledCost" />
              <Mapping SourceColumn="ActualCost" DataSetColumn="ActualCost" />
              <Mapping SourceColumn="TypeFk" DataSetColumn="TypeFk" />
              <Mapping SourceColumn="StatusFk" DataSetColumn="StatusFk" />
              <Mapping SourceColumn="estimateCompletionDate" DataSetColumn="estimateCompletionDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="up_Report_ProjectSummary_BudgetTableAdapter" GeneratorDataComponentClassName="up_Report_ProjectSummary_BudgetTableAdapter" Name="up_Report_ProjectSummary_Budget" UserDataComponentName="up_Report_ProjectSummary_BudgetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQL2005_390264_devpoleposiConnectionString (Settings)" DbObjectName="SQL2005_390264_devpoleposi.dbo.up_Report_ProjectSummary_Budget" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.up_Report_ProjectSummary_Budget</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="InspectionAmounts" DataSetColumn="InspectionAmounts" />
              <Mapping SourceColumn="InspectionTypeFk" DataSetColumn="InspectionTypeFk" />
              <Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
              <Mapping SourceColumn="Estimated" DataSetColumn="Estimated" />
              <Mapping SourceColumn="UnityValue" DataSetColumn="UnityValue" />
              <Mapping SourceColumn="subTotal" DataSetColumn="subTotal" />
              <Mapping SourceColumn="subTotalEstimated" DataSetColumn="subTotalEstimated" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="up_Report_ProjectSummary_IsssueTableAdapter" GeneratorDataComponentClassName="up_Report_ProjectSummary_IsssueTableAdapter" Name="up_Report_ProjectSummary_Isssue" UserDataComponentName="up_Report_ProjectSummary_IsssueTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQL2005_390264_devpoleposiConnectionString (Settings)" DbObjectName="SQL2005_390264_devpoleposi.dbo.up_Report_ProjectSummary_Isssue" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.up_Report_ProjectSummary_Isssue</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AmountAssets" DataSetColumn="AmountAssets" />
              <Mapping SourceColumn="ColumnName" DataSetColumn="ColumnName" />
              <Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SQL2005_390264_devpoleposiDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="SQL2005_390264_devpoleposiDataSet" msprop:Generator_DataSetName="SQL2005_390264_devpoleposiDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="up_Report_ProjectSummary" msprop:Generator_UserTableName="up_Report_ProjectSummary" msprop:Generator_RowDeletedName="up_Report_ProjectSummaryRowDeleted" msprop:Generator_TableClassName="up_Report_ProjectSummaryDataTable" msprop:Generator_RowChangedName="up_Report_ProjectSummaryRowChanged" msprop:Generator_RowClassName="up_Report_ProjectSummaryRow" msprop:Generator_RowChangingName="up_Report_ProjectSummaryRowChanging" msprop:Generator_RowEvArgName="up_Report_ProjectSummaryRowChangeEvent" msprop:Generator_RowEvHandlerName="up_Report_ProjectSummaryRowChangeEventHandler" msprop:Generator_TablePropName="up_Report_ProjectSummary" msprop:Generator_TableVarName="tableup_Report_ProjectSummary" msprop:Generator_RowDeletingName="up_Report_ProjectSummaryRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Utility_ProjectId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Utility_ProjectId" msprop:Generator_ColumnPropNameInRow="Utility_ProjectId" msprop:Generator_ColumnVarNameInTable="columnUtility_ProjectId" msprop:Generator_ColumnPropNameInTable="Utility_ProjectIdColumn" type="xs:int" />
              <xs:element name="UtilityFK" msprop:Generator_UserColumnName="UtilityFK" msprop:Generator_ColumnPropNameInRow="UtilityFK" msprop:Generator_ColumnVarNameInTable="columnUtilityFK" msprop:Generator_ColumnPropNameInTable="UtilityFKColumn" type="xs:int" />
              <xs:element name="VendorFk" msprop:Generator_UserColumnName="VendorFk" msprop:Generator_ColumnPropNameInRow="VendorFk" msprop:Generator_ColumnVarNameInTable="columnVendorFk" msprop:Generator_ColumnPropNameInTable="VendorFkColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ScheduledStartDate" msprop:Generator_UserColumnName="ScheduledStartDate" msprop:Generator_ColumnPropNameInRow="ScheduledStartDate" msprop:Generator_ColumnVarNameInTable="columnScheduledStartDate" msprop:Generator_ColumnPropNameInTable="ScheduledStartDateColumn" type="xs:dateTime" />
              <xs:element name="ActualStartDate" msprop:Generator_UserColumnName="ActualStartDate" msprop:Generator_ColumnPropNameInRow="ActualStartDate" msprop:Generator_ColumnVarNameInTable="columnActualStartDate" msprop:Generator_ColumnPropNameInTable="ActualStartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ScheduledEndDate" msprop:Generator_UserColumnName="ScheduledEndDate" msprop:Generator_ColumnPropNameInRow="ScheduledEndDate" msprop:Generator_ColumnVarNameInTable="columnScheduledEndDate" msprop:Generator_ColumnPropNameInTable="ScheduledEndDateColumn" type="xs:dateTime" />
              <xs:element name="ActualEndDate" msprop:Generator_UserColumnName="ActualEndDate" msprop:Generator_ColumnPropNameInRow="ActualEndDate" msprop:Generator_ColumnVarNameInTable="columnActualEndDate" msprop:Generator_ColumnPropNameInTable="ActualEndDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ScheduledCost" msprop:Generator_UserColumnName="ScheduledCost" msprop:Generator_ColumnPropNameInRow="ScheduledCost" msprop:Generator_ColumnVarNameInTable="columnScheduledCost" msprop:Generator_ColumnPropNameInTable="ScheduledCostColumn" type="xs:decimal" />
              <xs:element name="ActualCost" msprop:Generator_UserColumnName="ActualCost" msprop:Generator_ColumnPropNameInRow="ActualCost" msprop:Generator_ColumnVarNameInTable="columnActualCost" msprop:Generator_ColumnPropNameInTable="ActualCostColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TypeFk" msprop:Generator_UserColumnName="TypeFk" msprop:Generator_ColumnPropNameInRow="TypeFk" msprop:Generator_ColumnVarNameInTable="columnTypeFk" msprop:Generator_ColumnPropNameInTable="TypeFkColumn" type="xs:int" />
              <xs:element name="StatusFk" msprop:Generator_UserColumnName="StatusFk" msprop:Generator_ColumnPropNameInRow="StatusFk" msprop:Generator_ColumnVarNameInTable="columnStatusFk" msprop:Generator_ColumnPropNameInTable="StatusFkColumn" type="xs:int" />
              <xs:element name="estimateCompletionDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="estimateCompletionDate" msprop:Generator_ColumnPropNameInRow="estimateCompletionDate" msprop:Generator_ColumnVarNameInTable="columnestimateCompletionDate" msprop:Generator_ColumnPropNameInTable="estimateCompletionDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="up_Report_ProjectSummary_Budget" msprop:Generator_UserTableName="up_Report_ProjectSummary_Budget" msprop:Generator_RowDeletedName="up_Report_ProjectSummary_BudgetRowDeleted" msprop:Generator_TableClassName="up_Report_ProjectSummary_BudgetDataTable" msprop:Generator_RowChangedName="up_Report_ProjectSummary_BudgetRowChanged" msprop:Generator_RowClassName="up_Report_ProjectSummary_BudgetRow" msprop:Generator_RowChangingName="up_Report_ProjectSummary_BudgetRowChanging" msprop:Generator_RowEvArgName="up_Report_ProjectSummary_BudgetRowChangeEvent" msprop:Generator_RowEvHandlerName="up_Report_ProjectSummary_BudgetRowChangeEventHandler" msprop:Generator_TablePropName="up_Report_ProjectSummary_Budget" msprop:Generator_TableVarName="tableup_Report_ProjectSummary_Budget" msprop:Generator_RowDeletingName="up_Report_ProjectSummary_BudgetRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InspectionAmounts" msdata:ReadOnly="true" msprop:Generator_UserColumnName="InspectionAmounts" msprop:Generator_ColumnPropNameInRow="InspectionAmounts" msprop:Generator_ColumnVarNameInTable="columnInspectionAmounts" msprop:Generator_ColumnPropNameInTable="InspectionAmountsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="InspectionTypeFk" msprop:Generator_UserColumnName="InspectionTypeFk" msprop:Generator_ColumnPropNameInRow="InspectionTypeFk" msprop:Generator_ColumnVarNameInTable="columnInspectionTypeFk" msprop:Generator_ColumnPropNameInTable="InspectionTypeFkColumn" type="xs:int" />
              <xs:element name="ProjectId" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Estimated" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Estimated" msprop:Generator_ColumnPropNameInRow="Estimated" msprop:Generator_ColumnVarNameInTable="columnEstimated" msprop:Generator_ColumnPropNameInTable="EstimatedColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="UnityValue" msdata:ReadOnly="true" msprop:Generator_UserColumnName="UnityValue" msprop:Generator_ColumnPropNameInRow="UnityValue" msprop:Generator_ColumnVarNameInTable="columnUnityValue" msprop:Generator_ColumnPropNameInTable="UnityValueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="subTotal" msdata:ReadOnly="true" msprop:Generator_UserColumnName="subTotal" msprop:Generator_ColumnPropNameInRow="subTotal" msprop:Generator_ColumnVarNameInTable="columnsubTotal" msprop:Generator_ColumnPropNameInTable="subTotalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="subTotalEstimated" msdata:ReadOnly="true" msprop:Generator_UserColumnName="subTotalEstimated" msprop:Generator_ColumnPropNameInRow="subTotalEstimated" msprop:Generator_ColumnVarNameInTable="columnsubTotalEstimated" msprop:Generator_ColumnPropNameInTable="subTotalEstimatedColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="up_Report_ProjectSummary_Isssue" msprop:Generator_UserTableName="up_Report_ProjectSummary_Isssue" msprop:Generator_RowDeletedName="up_Report_ProjectSummary_IsssueRowDeleted" msprop:Generator_TableClassName="up_Report_ProjectSummary_IsssueDataTable" msprop:Generator_RowChangedName="up_Report_ProjectSummary_IsssueRowChanged" msprop:Generator_RowClassName="up_Report_ProjectSummary_IsssueRow" msprop:Generator_RowChangingName="up_Report_ProjectSummary_IsssueRowChanging" msprop:Generator_RowEvArgName="up_Report_ProjectSummary_IsssueRowChangeEvent" msprop:Generator_RowEvHandlerName="up_Report_ProjectSummary_IsssueRowChangeEventHandler" msprop:Generator_TablePropName="up_Report_ProjectSummary_Isssue" msprop:Generator_TableVarName="tableup_Report_ProjectSummary_Isssue" msprop:Generator_RowDeletingName="up_Report_ProjectSummary_IsssueRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AmountAssets" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AmountAssets" msprop:Generator_ColumnPropNameInRow="AmountAssets" msprop:Generator_ColumnVarNameInTable="columnAmountAssets" msprop:Generator_ColumnPropNameInTable="AmountAssetsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ColumnName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ColumnName" msprop:Generator_ColumnPropNameInRow="ColumnName" msprop:Generator_ColumnVarNameInTable="columnColumnName" msprop:Generator_ColumnPropNameInTable="ColumnNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectId" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:up_Report_ProjectSummary" />
      <xs:field xpath="mstns:Utility_ProjectId" />
    </xs:unique>
  </xs:element>
</xs:schema>